How to: Run Microsoft Query in Excel.
Solution:
Select the MS Query 'Records' menu, then select 'Automatic Query' or select the 'Records' menu then select 'Query Now'.
NOTE 1: Queries can be executed manually or automatically each time fields are added or removed on the data pane, or when changes are made to the criteria pane.
NOTE 2: When a query is first created or if major changes are made to the query, turn off Auto Query to keep from waiting for the query to execute after each change made. A check mark beside 'AutoQuery' signifies that it is on.
Steps:
1) To run an automatic query:
a) Select the MS Query 'Records' menu.
b) Select 'Automatic Query'.
2) To run a manual query:
a) Select the 'Records' menu.
b) Select 'Query Now'.
